Cross-Tab tab

The Cross-Tab tab contains the basic functionality you need to create a cross-tab. You can define rows, columns, and summarized fields. As well, you can create groups and formulas directly from this tab.

Columns

This list displays the fields that you have selected as column headings for your cross-tab. If you have multiple column headings, they will appear on your report in the order in which they appear on this list.

To add a column heading to this list, select a field from the Available Fields list and then drag it onto the list, or click the Add Column button.

Rows

This list displays the fields that you have selected as row headings for your cross-tab. If you have multiple row headings, they will appear on your report in the order they appear on this list.

To add a row heading to this list, select a field from the Available Fields list and then drag it onto the list, or click the Add Row button.

Summarized Fields

This list displays the fields that you have selected as summarized field headings for your cross-tab. If you have multiple summarized field headings, they will appear on your report in the order they appear on this list.

To add a summarized field heading to this list, select a field from the Available Fields list, then drag it onto the list, or click the Add Summarized Field button.

Available Fields

This list displays all the tables and fields that you have activated for use in the report.

Select the field you want to use and drag it into the appropriate list, or click the appropriate Add button. Repeat this process to add additional fields.

Add Row

Click this button to add row headings to your cross-tab. Fields selected in the Available Fields list are moved to the Rows list.

Add Column

Click this button to add column headings to your cross-tab. Fields selected in the Available Fields list are moved to the Columns list.

Add Summarized Field

Click this button to add summarized fields to your cross-tab. Fields selected in the Available Fields list are moved to the Summarized Field list.

Remove

Click this button to remove the selected heading or summarized field from your cross-tab.

Group Options

When you click this button, the Cross-Tab Group Options dialog box appears. Use this dialog box to enter a group for your cross-tab. Group Options is available only for rows and columns.

Change Summary

When you click this button, the Change Summary dialog box appears. Use this dialog box to change the summary type of the cross-tab's summarized fields. Change Summary is available only for summarized fields.

New Formula

When you click this button, the Formula Name dialog box appears. Enter a name for your new formula and then click OK. The Formula Editor appears so you can create the new formula.

Edit Formula

When you click this button, the Formula Editor appears. Use the Editor to edit the selected formula. Edit Formula is available only when a formula field is selected in one of the lists.

Browse

Use Browse to view the values for a field you have selected in the Available Fields or Summarized Field lists.

Related topics

Formula Editor

Insert Group dialog box

Change Summary dialog box



Seagate Software IMG Holdings, Inc.
http://www.seagatesoftware.com
Support services:
http://support.seagatesoftware.com